Child Immunisation Analysis and Open Exeter Upload

The Child Immunisation Analysis report provides a full analysis of all the child immunisations ideally for those under 6 years of age. The age may be adjusted to suit.

It also includes a output that can be uploaded to Open Exeter based on MMR, 5IN1 or 6IN1, MENC and Booster. for those sites that submit their immunisations this way.

The Excel workbook shows immunisations for: MMR, DTAPIPVHIB or DTAPIPVHIBHB, DTAPIPV, MENC, HIBMENC, MENB, ROTAVIRUS, PNEUMO, FLUSIN

Each stage displays on a separate tab with information about each immunisation.

If there are multiple stages an analysis tab displays what stages have been given (or not), when the next stage is due and how far outside the due date it was given in days.

This report provides the practice with a complete picture of all the child immunisations in the practice.

Note - It may take a few minutes to compile for practices with a large list size, as it shows all immunisations for each child within the age group entered.

Download

Updates

  • Updated 11/02/2019 v2.7 - Date on README sheet was being entered in wrong format i.e. mm/dd/yyyy. This has now been fixed to show as dd/mm/yyyy.
  • Updated 11/02/2019 v2.6 - Fix applied to List date in new year when working out age.
  • Updated 06/01/2019 v2.5 - Fix applied to Open Exeter button that compiles the CSV file in XL2007.
  • Updated 30/04/2018 v2.4 - Excel code updated to accommodate for single GP practices. Where there was only one GP Partner in the Staff list the formula wouldn't work and displayed VALUE errors. This has now been resolved.
  • Updated 17/04/2018 v2.3 - Immunisations under GMS now include those given "In another practice" as well as "In this practice". Those with a source of either "Out of practice" "Unknown Source" is not marked as under GMS.
  • Updated 25/01/2018 v2.2 - Only GIVEN immunisations are now counted in the Open Exeter report. You can now enter the DATASOURCE (HA Cipher) which only includes GP's assigned to that HA code. The final Open Exeter (IMMS tab) lets you review and amend (if necessary) the data before it creates the upload file for Open Exeter.
  • Updated 17/12/2017 v2.1 - This new version includes the 6IN1 vaccine and takes the Open Exeter GPCODE from the patients Registered or Usual GP and the DATASOURCE is the assigned TP/HA/CSA links code for the GP (set up in Control Panel - File Maintenance - Staff - Identifiers).
Note - To print this topic select Print in the top right corner and follow the on-screen prompts.